Export as SQL File
Overview
This function lets you export data from Lotto Sorcerer into a SQL formatted
text file. This is intended for importing the data into an SQL-92 compliant
database, as well as sharing data with another user of Lotto Sorcerer. You
can also use this to export data back into Lotto Sorcerer.
Please note that unregistered versions of Lotto Sorcerer are limited to 50
records for exporting.
How to Invoke
Use the menu item "Lottery Data > Export Lottery Data > Export as SQL File" .
Basic Procedure
- Select the lottery you want to export
- Enter the tablename to be used in the SQL file's "insert into..."
clause
- Enter the date field name
- Enter the time field name
- Choose optional parameters
- Enter the field prefix to be used
- Choose the End-of-Line terminator character(s) to use
Window Controls
"Select Lottery" dropdown
Choose the lottery you want to export.
"Tablename" text box
Enter the tablename that will be used in the SQL file (in the 'insert into…'
clause).
"Append Semicolon" check box
If your database expects a semicolon after each SQL statement (most do),
check this box.
"Draw Date" field name text box
If you are using the "Include Column Names" option, enter the field name for
the date field.
"Draw Time" field name text box
If you are using the "Include Column Names" and the "Include DRAWTIME Field"
options, enter the field name for the time field.
"Field Prefix" text box
Enter the field prefix to be used. Lotto Sorcerer will automatically append
field numbers (from 1 to the number of fields after this character).
"Include Column Names" checkbox
If you wish to use the field names in the 'insert into…' clause, check this
box.
"End-of-Line Terminator" dropdown
Different operating systems use different characters to mark the end of
line. Choose the appropriate one.
Export button
Clicking this button starts the export process.
"Cancel" button
Use this to close the current window and return to the Main window.